SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506742 LIMIT 1 [ RunTime:0.000496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506742 [ RunTime:0.002527s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (389222,400070,985374,56187,967530,422316,575731,121778,12340,259133,76345,1048279,713235,719447,295999,232476,937803,429742,356200,1011016,904092,582600,351244,322305,522798,991788,784184,474700,698313,980356,330769,1025356,1010133,404426,62539,678579,816352,963203,198006,697649,893826,918530,163528,114599,1024559,1020111,347210,392724,91189,722325,1016706,705728,233849,877133,219107,559386,710125,249765,670371,946177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506742 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506742 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]