SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 721713 LIMIT 1 [ RunTime:0.000279s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 721713 [ RunTime:0.002509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291075,510514,14678,761991,469264,928984,149993,464545,596375,684960,928047,388269,861064,608492,967873,521641,13222,618124,61795,1046941,520444,648695,197118,1029445,589042,93566,960636,625313,967268,832663,170228,45926,646067,498969,353229,224167,509080,892167,25496,200187,490020,550178,112380,235972,540401,182603,929333,278653,4671,677324,470640,709029,887948,1037130,653493,370565,687752,167849,789470,670721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003732s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 721713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 721713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002174s ]