SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004870 LIMIT 1 [ RunTime:0.001847s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004870 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548560,440822,377537,1000400,745614,731210,698711,1004924,727583,296904,203202,977854,682598,404322,298554,430055,484262,354138,921294,39592,130830,211163,986996,389906,108030,931947,364899,22538,344751,620029,285023,141759,1018512,144563,590899,348042,525450,841675,159276,936644,332859,537927,657066,38562,815140,845647,160203,132816,590150,453630,63272,165181,651012,431046,328786,325254,972952,636622,949525,924240) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004870 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004870 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]