SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511522 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511522 [ RunTime:0.003864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332100,128076,988468,233064,699523,845859,928956,96917,55149,384735,255528,744634,794979,831075,640357,237346,302604,78721,282549,744830,112297,245580,332044,452827,605719,276753,146388,120761,343985,39648,156729,389185,607123,827482,64178,769952,960609,997482,815686,160465,87633,401413,85344,561654,58783,215735,1011489,893007,714559,979220,312457,495778,330658,761274,879420,450341,413130,1040073,566283,82582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]