SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508153 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508153 [ RunTime:0.001862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474259,130903,1047196,497084,727101,567847,648957,427178,785185,731060,530034,695523,521683,468512,339215,641980,519283,504070,320476,501373,54102,875702,66473,766874,594108,344689,964041,581377,953767,583124,200955,615554,335978,494855,88129,605067,556142,519615,890786,224448,1002893,720217,810743,573467,584131,142120,248739,549501,757076,334312,214606,804852,443632,276167,915943,468385,801442,278258,65423,664633) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508153 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508153 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]