SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491962 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491962 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119598,975614,216176,34041,442497,756883,926706,205567,375943,584358,183764,529449,518580,184337,260582,551409,324566,326090,115444,828156,797657,1020153,547656,228660,64300,371822,912625,145557,398113,473934,574668,237568,573551,619297,480607,151846,742256,480639,982140,533880,372140,152879,1023272,404667,1002929,1038225,720050,676770,58034,738909,158319,904824,665025,1014700,502740,310348,534208,481733,836017,415186) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491962 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491962 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]