SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428993 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428993 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (770190,380705,761486,470795,608484,692029,817577,269101,974973,920131,642047,1020952,515839,437890,960105,138877,406500,118295,421583,756411,948594,624998,1043199,992543,676321,745093,1007480,638921,806825,764235,971830,229226,338397,978244,253208,816537,561257,859274,308240,950956,681924,308026,579975,677470,131989,23157,561718,759089,359711,834703,1002615,940086,833362,793996,257732,1032868,306819,614430,964881,777919) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]