SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560983 LIMIT 1 [ RunTime:0.000495s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560983 [ RunTime:0.002254s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (571734,157866,543653,414192,685713,703798,965072,499081,549758,334317,18651,192140,133796,1006172,143533,64761,1031877,229071,646009,388177,497867,687721,766970,1013958,85899,322633,261353,1037130,938981,950944,443192,859486,217555,897089,402104,641214,148404,612750,263123,839200,605887,318918,925780,505588,980914,532603,218630,944102,350027,452562,123467,914927,9900,877032,346140,316868,346549,297621,619985,967391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]