SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012543 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012543 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789947,622489,154659,623471,265303,185536,139750,1012814,726803,86135,332955,103416,682876,290494,1020236,1007943,26022,246690,453037,886255,457666,672324,710778,192178,661178,32705,949800,788307,717474,77752,265517,559446,361948,974156,41382,540168,510404,270371,107639,105608,341593,133730,642713,157820,980420,61760,196990,373276,204640,111526,273499,541487,825743,112712,417135,266413,607590,456199,581178,641617) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]