SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560702 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560702 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045164,343179,433784,201924,331516,513264,145046,437959,164870,146214,609951,378559,98268,58344,334955,450728,455972,21163,710740,701075,279052,204092,1005821,180111,411897,334805,143933,341355,369761,175247,397249,967618,308140,910417,1024553,28463,245964,282148,435956,191798,407503,849864,659039,385827,268636,969722,21182,128080,621156,1920,472537,985826,644976,990178,926819,511416,140457,541125,746182,757959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560702 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560702 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]