SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100416 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100416 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (864076,1018898,596426,403813,626723,686415,146153,420942,154915,783755,1019434,22249,742668,760891,98517,733157,587583,742003,936504,677594,964052,198315,486161,734773,974859,623989,730708,864258,685547,136220,877148,136110,784926,216577,194658,721798,283067,871245,441475,951013,244244,867666,36726,796124,762871,213168,590615,992646,154691,724965,190275,861723,107554,752624,46916,804462,864287,613109,273384,992974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]