SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029344 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029344 [ RunTime:0.003783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (687742,998400,855580,477393,355961,686120,451106,122413,652128,614505,378534,604370,629867,263971,875868,860794,245419,751072,436432,1045894,489409,38930,215577,766144,209214,1038844,665464,807116,67134,544645,292072,780895,441787,895470,677565,138786,51221,564895,223358,198324,569362,518817,552216,364877,643552,571738,402860,195959,222955,523337,951726,148799,71073,804755,78286,317653,486009,236356,836743,372254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029344 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029344 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001329s ]