SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283191 LIMIT 1 [ RunTime:0.000681s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283191 [ RunTime:0.002367s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703442,190205,298917,47913,839578,599455,760152,1022236,225641,507218,919497,352964,15321,563877,291748,371997,360916,116440,150978,364305,925575,396054,59615,693930,590073,874213,277362,789364,420216,206107,444695,857459,800304,81814,683203,314803,60749,122507,342491,992119,340104,531681,701619,498906,111556,545724,166990,124996,706743,145188,516089,601290,378161,324442,339963,657951,630025,775264,952470,151836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000676s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]