SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 299005 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 299005 [ RunTime:0.002511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314580,97716,292815,238017,613313,299489,951432,484379,310582,770384,675443,859015,911591,748677,69267,349519,211944,205977,877406,222545,66046,217872,120233,1024981,1034569,964894,898460,329098,311577,373771,670880,145675,691343,502570,856910,318263,370892,534135,928311,436721,350301,207659,927036,488498,680720,603471,942461,993222,201359,654962,345344,526237,485953,731259,152750,723020,231772,389002,911855,940015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001880s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 299005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 299005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]