SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041715 LIMIT 1 [ RunTime:0.002600s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041715 [ RunTime:0.002761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (834499,970324,198441,331588,1008992,457522,832118,175623,366190,328511,917979,645279,257881,372899,215259,62415,455822,515077,94043,358344,806495,955090,985440,768129,358736,120120,142497,595556,660662,839962,176330,444377,657833,321513,229402,152128,302461,169035,629009,853323,774625,716173,190623,714338,660729,277916,232177,50170,22698,962244,568388,937606,165113,133652,836549,913473,651892,189382,864011,843434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041715 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041715 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]