SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 244914 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 244914 [ RunTime:0.003578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (832044,240634,541903,58936,1006080,190223,398461,710282,760493,167327,637246,392257,545909,723362,111565,384110,432812,122041,30412,673818,305580,438969,140163,872795,705311,96900,463549,1038196,593061,236743,631478,780520,219544,1046773,811351,785838,379918,808985,385376,552263,903549,170040,34360,117560,874530,281976,761347,690285,491149,715820,21189,513809,941151,556466,670180,684280,578348,169326,843175,274025) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 244914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 244914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000816s ]