SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286650 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286650 [ RunTime:0.003714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334816,805493,16544,205152,382842,589312,644155,194548,216660,792800,631262,359398,470648,804308,356617,24193,177342,789691,122180,917949,110534,778480,619533,957119,429158,665742,390033,444473,195128,553271,707669,276352,356982,893149,211880,473842,820764,875386,1040537,376226,988570,354661,602976,1007047,134265,369780,433283,418492,774033,163941,440648,123367,76411,127442,217085,288265,919023,926464,321804,210017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]