SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801193 LIMIT 1 [ RunTime:0.006709s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801193 [ RunTime:0.001793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037049,107513,216686,269107,818636,118734,155351,607095,313018,62464,598249,354988,1011888,498687,1006341,267688,624261,994622,11215,200695,438652,516818,113159,821902,996085,399454,345293,157997,603436,296636,620158,906714,395722,235086,703245,51596,703171,733410,93179,842363,935631,978335,767295,162083,725914,567530,695497,741766,989395,289664,365121,339633,278704,999103,380994,1011753,554230,7091,684601,61048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006783s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]