SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001610s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300208 LIMIT 1 [ RunTime:0.000561s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300208 [ RunTime:0.002291s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945827,813823,638297,918995,174690,372687,318894,414657,850645,666049,565246,216921,212038,924199,713384,781158,942647,778086,436834,375242,791896,723205,142323,996088,136052,989585,715687,947268,438203,486152,609990,441465,515389,805036,183222,1016733,82892,601957,42121,957133,788194,184733,528689,658571,521196,389602,1019705,110632,211795,904618,373375,16065,366336,580596,234600,346210,575922,421730,678320,1009676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000700s ]