SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502017 LIMIT 1 [ RunTime:0.000665s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502017 [ RunTime:0.005568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (855144,571943,801167,100345,287406,1013739,445144,697279,957993,16975,1016349,265632,387565,620454,832554,174058,183208,801623,988628,251301,680637,198652,178804,255290,507591,39906,561597,553992,354693,845335,101689,792414,98876,125146,571549,622178,112788,366489,376637,139775,128753,613121,890367,559867,472239,587271,657389,650080,410053,437615,804845,155705,814393,705635,761813,482127,626029,332091,791351,545701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]