SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154108 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154108 [ RunTime:0.003208s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429017,91301,728335,768786,543293,610588,983656,778350,387227,983015,17908,403055,574555,922167,516515,969397,1042654,443143,483836,243297,968762,537093,238421,701507,953027,212723,780064,605529,809230,107301,433764,22300,10711,567060,248103,663974,977969,79817,100032,1029330,349318,607434,682139,109324,200813,962755,953348,1017483,999208,797725,423597,492914,756548,5906,705152,2697,455677,75534,192465,20502) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]