SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105852 LIMIT 1 [ RunTime:0.001149s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105852 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88517,446215,605998,434082,55328,425590,883794,742801,78334,902705,692907,350479,607996,376702,715106,399824,658774,424023,879935,148001,541584,370551,666132,124090,427282,642934,584292,668710,495934,177082,911770,884068,515235,604267,462237,496037,244558,884184,279001,780150,507639,656778,330567,667699,296231,506136,93400,769643,256145,790863,985926,19299,822957,234989,257981,406898,766983,1043339,990053,532335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105852 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105852 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]