SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312068 LIMIT 1 [ RunTime:0.000559s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312068 [ RunTime:0.005304s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628229,490860,292408,505131,16107,1036391,212476,846903,161196,419725,720473,287268,438694,953915,59244,167676,129041,631887,1443,232549,136938,370772,752344,780991,374580,1024648,280984,719990,858569,79845,60527,177672,22294,534942,961433,590935,134441,37426,509105,655424,36179,590068,1012624,435242,674666,303578,791596,165382,162537,537953,605176,644705,171800,207849,623649,685845,191208,412010,533419,498167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000705s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]