SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533994 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533994 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372224,60645,712457,340654,344039,707709,603068,964058,101902,825189,270366,684045,641074,725319,2765,1005090,687625,597282,205616,1041573,205621,195564,104650,785268,330078,667650,165593,762323,797800,414678,982892,774756,901081,441006,144324,760094,424442,686322,886518,830326,896652,192148,1019462,748230,234678,660264,345180,127109,756454,846424,484388,574070,870172,661442,829088,725434,208017,167677,668719,192085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533994 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533994 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]