SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414301 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414301 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (867325,76375,244338,530923,606579,961624,724140,7402,524133,600053,940260,775094,786207,730237,693056,557858,433655,984764,941157,584620,188034,1036531,184141,941360,77485,267356,401810,955907,258773,617708,272443,686352,820782,125524,1007607,412623,285651,151743,11047,346679,578518,967555,649133,310794,615169,571666,631332,830229,473973,269591,675053,402192,103408,360843,249081,516332,203991,155045,101428,776196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]