SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292128 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292128 [ RunTime:0.002753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (30578,903971,577409,432652,677215,870824,804133,255041,416601,906256,151938,959015,12725,674737,423150,913944,1020086,761053,575944,289450,566714,360346,103577,676884,186928,671065,717203,200993,185189,418451,120585,546811,124897,19758,177964,694994,418022,535794,899516,128999,297881,407297,995444,948577,677686,464126,51258,383551,212568,726728,1035561,991600,798737,144262,1006560,1014979,2988,880385,588597,923948) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003774s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]