SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50632 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50632 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415744,720855,536301,636936,969323,400830,688057,499573,796413,520959,473615,550833,122513,543188,366873,143325,988948,475477,228012,891121,108944,597026,686313,444122,815384,980628,563244,900191,868421,940857,1018621,159679,597552,200813,731214,897964,246995,37392,780172,607097,11327,1025268,745844,516558,69533,526313,857627,474487,636496,641547,43815,371965,730844,82650,886622,442017,35006,444441,527121,588081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50632 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50632 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002717s ]