SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562018 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562018 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15029,246609,351380,331636,1019255,191979,1002316,222147,359085,647530,937783,129581,761567,13416,351744,788426,342434,1012030,295528,873057,257618,855878,630153,368843,372073,428746,1018172,872405,651013,1037804,442443,304256,306419,651764,859196,88081,958063,401728,794109,500845,99665,373315,512098,1020387,824033,508133,862558,1008429,558454,616444,470952,963158,7551,619813,720585,706006,255272,744694,380621,310080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]