SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042671 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042671 [ RunTime:0.002309s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038387,861391,985677,238119,903397,859842,301455,491939,638646,304741,172110,527117,973758,850291,339243,929094,459139,154409,135452,139022,998832,225346,14150,412045,67902,280806,217838,420664,463723,314746,273082,941970,21777,1018763,173558,1008403,113326,907781,35155,696293,692537,633181,413488,798954,344285,194011,1041848,449449,341895,871102,1012047,124014,183737,153185,742217,295244,853766,742974,143845,186543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]