SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 321458 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 321458 [ RunTime:0.002069s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (885986,440740,217043,793214,393269,284011,939512,835361,96165,579767,768965,424800,795488,355388,250049,500615,284539,369921,50547,1029140,526715,405487,1035269,287379,1016233,972432,1046333,208611,431807,272523,549602,77844,681195,232345,918043,495755,209469,319670,817348,986405,391289,695638,431617,913903,943269,229404,31164,736155,781664,805082,524588,218588,321995,201678,85281,135993,143043,562647,386289,288970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 321458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 321458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]