SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404860 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404860 [ RunTime:0.001910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203361,230583,102012,746883,747739,683696,568043,348059,514331,651090,402645,600501,54927,442301,631595,134838,676820,382482,667509,1024961,395297,959952,1176,39073,239522,126564,705848,369301,595139,431069,222268,559047,983818,590658,489429,847176,131566,640214,1030361,968995,257415,1019928,144411,774176,135538,618982,932108,500275,454210,247927,319684,6362,882262,888822,212040,1007344,413316,796246,105836,395130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]