SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101517 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101517 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (538649,164177,522196,560532,604621,420358,268232,335950,1013287,345369,569589,836106,906282,37068,668812,359105,627130,552280,535166,715632,393948,332324,721738,321748,479260,887331,471005,655895,884936,918337,372790,289772,473586,340607,605633,11812,205422,235807,27579,90485,339002,607088,95272,713649,834659,316786,904375,326290,914975,258830,825518,411968,176469,626094,337699,165066,473674,354895,660492,915969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]