SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330096 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330096 [ RunTime:0.001954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (821809,605949,994233,54430,431626,736407,1030033,51278,943313,693710,269731,1013672,227944,552442,736357,944288,531646,854350,934121,208140,968482,38804,734058,593228,507365,266634,564503,39512,428551,965964,960740,637054,489631,152165,1015230,161890,575677,973897,258211,93247,1016504,256024,540883,980479,74826,1001043,1008184,489597,737889,218149,796981,652765,963759,344576,911488,379388,316023,27268,967026,51036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]