SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520058 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520058 [ RunTime:0.001944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (963474,845148,712210,245753,830807,341747,851858,520875,659982,111965,611802,614326,949652,720694,969727,225985,12608,795833,1044576,677010,383066,429387,767513,476863,235813,256236,418934,726146,262207,15152,568741,705993,609130,706459,57929,42828,682306,384746,107658,301546,437293,19851,570949,275264,767289,778399,128125,803570,961380,773134,199537,87495,481477,933550,26990,530753,940134,624946,490566,794736) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]