SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200915 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200915 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (730913,796405,60695,601389,196586,306224,169472,230732,990601,424881,400254,294386,191947,907002,544557,396778,320111,333374,3571,273028,65095,967027,517096,65901,599016,613717,969661,801722,497065,342560,110568,941674,638471,470123,963327,996422,404598,710016,883862,163574,397098,667389,81667,103833,365296,919457,541976,757917,466262,205706,100130,62841,290617,598957,473911,432899,978397,693512,860738,787274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200915 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200915 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]