SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336547 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336547 [ RunTime:0.001716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (915456,1016655,772422,154633,219172,192948,209221,255119,532958,386237,403583,131390,612048,997411,973943,481708,415570,618677,456386,435271,874786,913697,189227,134345,890540,616211,398582,76883,635623,69614,110169,164168,629186,682197,560167,840296,920127,453553,831687,469200,234971,950047,175844,458919,435202,103140,523276,167144,897487,72847,437423,885438,353638,746298,795221,235650,501131,554029,121090,231671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336547 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336547 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]