SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311763 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311763 [ RunTime:0.002801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902987,1030005,622589,450351,826902,229592,216806,671678,1015387,257046,808580,392398,744787,1012543,694550,318064,543636,838508,580912,396421,198574,105593,634505,391550,140547,215141,743198,59603,968409,207052,420426,967553,452939,558757,448352,801491,390442,637051,743276,64215,223846,131704,642953,145929,361700,277881,49423,809260,574917,191951,580686,981965,568006,410780,696553,559387,1019300,274434,1034339,137116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311763 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311763 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]