SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 134864 LIMIT 1 [ RunTime:0.001174s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 134864 [ RunTime:0.002493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (380045,701666,23120,39738,568726,51371,29770,1003294,985430,471907,726371,303300,426619,893163,1004342,175371,681592,50409,680288,960172,413473,647390,11992,879088,532027,282335,54559,758876,254542,81725,255657,757647,79925,1010067,966725,909616,793867,83778,947283,867376,309667,205132,529394,836547,269354,394453,1042934,646924,501482,782593,622911,999094,559874,934445,990901,748141,295434,764888,632301,775910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 134864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 134864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000739s ]