SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354850 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354850 [ RunTime:0.003359s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498716,100597,269123,801962,264632,440607,626330,922596,963433,800104,690321,575893,459670,402952,1037419,119038,953418,396939,532906,780998,835970,700141,1012298,646641,1008050,99739,910272,684894,267923,527301,1034838,344361,248067,564382,7707,554710,426526,397605,326200,117415,636257,6444,938419,203423,220416,423610,850863,178029,360377,171337,123530,310940,1001591,65287,77293,204584,688788,437853,266143,143632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]