SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201681 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201681 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146182,508309,529963,516482,254854,379926,493725,584171,802303,421164,950484,549557,339846,741775,649670,524669,153590,686971,1014855,694979,64969,334800,1015690,324698,469092,607700,19287,804586,239044,175188,109176,324076,671477,922574,669815,398533,544509,615213,699815,405862,242616,640295,943816,476599,557824,235214,219912,941795,546970,173966,527439,30999,218701,958057,811874,106722,638196,258348,967545,311628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]