SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150380 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150380 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398034,374372,948036,63611,1032874,55253,16272,874811,80506,183377,810719,1042964,641665,683180,387340,149448,18720,860025,215285,122302,684930,613546,478125,807970,1007086,951201,242852,915865,193255,187690,76049,560510,755201,694991,709651,182507,363302,899416,124693,512837,896712,919778,896448,912797,517622,781781,950571,760500,1031763,488231,387867,624821,953895,247535,419570,133973,271854,87643,147110,854556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]