SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105580 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105580 [ RunTime:0.001304s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (831693,626386,585016,704744,36463,80953,152457,102206,35434,89676,518896,53551,972902,132216,1029783,584330,936092,791170,114367,966916,1032532,404779,652632,343834,60318,288163,481685,796222,254508,49178,498009,586050,845468,122962,359444,272642,621907,861418,403909,925434,347604,1004553,536555,418125,938639,234223,645248,865098,769504,612519,897844,449235,863812,345192,162931,694335,423393,595508,712349,348996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]