SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001772s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802799 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802799 [ RunTime:0.002213s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419474,518469,289003,801018,458729,252380,266511,569480,141965,285077,159035,323330,500659,651047,189761,484315,282619,303809,498542,475552,888389,785150,783420,441589,565006,585831,414685,609985,162517,232762,1038434,504466,840962,638477,811037,303147,242475,358200,513670,853386,5563,32314,305046,444085,45196,117352,638062,988696,871242,1045881,581895,981955,606902,571853,517771,1010572,845261,282712,624675,396192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802799 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802799 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]