SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519634 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519634 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453604,402618,633883,446457,437642,1018833,915188,668781,621705,1037926,996314,104429,748359,972608,578291,1016161,46496,241052,87359,610992,623724,931942,667708,977077,730640,563821,699138,210957,1010308,912339,692764,940429,590769,318958,324280,1001466,494646,472397,954512,211167,355824,87591,819332,930163,337094,842453,973440,620064,696910,448306,867578,861560,857561,155984,518483,268829,605014,290121,762287,1009819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519634 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519634 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]