SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421584 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421584 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10973,730548,206545,179498,449571,344804,201105,465805,822484,70845,826153,274108,886253,644506,836638,783846,628661,320366,974466,30976,769675,89742,199245,918163,293357,277820,144924,1006701,1003245,221631,217103,159155,1044960,1013916,371845,173684,215217,789353,1044906,785090,27844,444572,655936,724852,1004324,494941,709313,853558,437160,21702,42269,492882,1018973,1009340,969794,765729,608753,412881,229088,199527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001911s ]