SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474052 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474052 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804392,175651,134816,170807,639948,816281,407053,741122,846748,957377,367160,940161,171200,989940,388806,933061,704289,42425,597852,462908,136922,1000210,354591,298540,761790,801023,799113,601543,966884,505283,344706,757984,638503,386296,485307,788746,749538,238955,175909,757020,991591,332901,62161,887234,331982,478817,374921,840700,32440,446100,173639,151044,505914,533198,595546,735715,992284,458831,851877,584136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]