SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419351 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419351 [ RunTime:0.002708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830002,78354,599920,195849,458243,356296,400230,63575,979555,526572,648510,304816,600110,46870,518461,816055,393377,136533,335310,751685,222017,998275,343857,253248,546617,291703,193609,722040,239272,836576,821195,614771,597288,154849,886569,216679,839216,916035,563834,481309,886175,832726,31663,630390,608245,836392,949905,1018605,988137,722982,785980,418537,654683,223342,828588,388230,436923,74000,599392,691595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419351 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419351 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]