SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001648s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 675662 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 675662 [ RunTime:0.002788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506541,700062,993908,1025119,464530,599797,172486,653445,878414,570579,425628,599162,897238,345548,218996,830494,358576,662032,374504,345940,697674,904481,407803,855249,316520,174684,1005926,189345,441147,900871,451509,428034,463739,583414,346552,144259,84630,911102,992712,723134,290593,1003529,664532,1009003,913028,226976,1025835,697982,502564,747343,732513,762340,746456,146183,659827,1023364,860942,768045,231703,775712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 675662 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 675662 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]