SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292840 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292840 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440366,999382,935612,451574,983028,467151,1040114,567483,388147,588161,326334,680159,353870,142105,8035,959318,988591,482512,250069,789544,695078,427725,361640,432012,316806,131134,444464,965777,408394,428453,114747,791879,317931,18129,634567,272309,699221,285791,184723,1016476,796659,1041494,112298,311874,38180,971687,251143,998318,323928,213991,533456,83427,77692,427498,523443,102274,103233,506697,278988,161435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001529s ]