SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504385 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504385 [ RunTime:0.002122s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (136453,776789,31506,619090,326278,141410,32011,151434,549920,824603,96820,394892,436985,1010018,240369,211598,540844,508697,953131,737754,349424,34097,774434,530835,267970,497356,709534,180735,911236,906405,812804,901034,929956,42018,85641,710953,209863,905132,205484,355244,899767,553229,1034005,111958,990278,473178,706273,214142,123627,259890,600103,615469,335841,1000438,339277,398531,837502,778269,540807,207625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504385 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504385 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]