SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024481 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024481 [ RunTime:0.004432s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148906,711725,1027950,7997,541832,586078,445621,249481,259998,784932,586439,834000,293440,996366,999641,447550,561434,865559,84623,35435,937248,230781,204706,1016164,737916,710974,896699,454239,689205,921319,1044775,120287,497251,524187,466723,825534,152239,967100,677871,899407,897609,7218,87363,136588,436543,248484,1010162,774695,1025625,62985,184901,1010403,929878,636637,702735,573723,564512,906821,805751,798094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]