SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543020 LIMIT 1 [ RunTime:0.000528s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543020 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014638,723829,636211,895900,29490,363823,540450,66132,542073,993090,790496,420428,913071,1048632,155163,992274,483588,606538,337227,798757,495733,34147,875097,4104,629974,237562,48454,148702,718106,1002795,527628,848103,626625,491314,48501,272405,513862,777867,234698,424292,523477,833963,54611,286412,615723,181750,280412,365487,1021797,120712,555867,992874,942710,858192,157070,156997,208744,388117,834336,274843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]