SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418393 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418393 [ RunTime:0.002669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012697,345365,26056,407096,1011166,849642,891605,879179,708479,652906,382511,679701,306252,664437,926568,734984,363744,274456,808181,36987,72285,824613,958850,461389,345855,816887,611751,970580,513415,79269,696192,731900,875997,708502,460909,727214,369785,248111,323001,904912,583891,672646,326770,393148,106734,981707,157191,941579,532738,275544,340678,884440,110510,719516,1023580,356203,730673,335933,911043,437049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]