SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458337 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458337 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424020,386478,678872,511032,61881,436512,99476,219423,884586,179110,268898,713572,93404,432481,197485,98707,265785,70144,811289,832711,362832,575188,404478,25198,426711,598230,284026,622739,807847,841256,616954,481356,401092,489745,341777,867967,464803,849737,971084,888309,296459,633909,489882,415186,366259,1001865,253728,810126,377252,653725,1021695,74561,137867,1016211,976986,412567,1970,407997,559529,980797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458337 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458337 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]