SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025973 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025973 [ RunTime:0.002238s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789929,937870,448106,289119,886755,891562,796919,1016770,902916,98017,312348,480017,794534,131230,722882,466847,614903,856386,294880,542019,143186,469557,391542,381380,843626,128704,86565,410839,902225,952318,118264,509833,847969,245741,522779,601554,224784,534959,857436,367176,221645,247842,514248,519421,3243,85253,194357,980743,904629,730216,655465,825482,350154,389705,367972,520499,1031351,583536,941873,734485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025973 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025973 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]