SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001499s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580215 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580215 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (27761,1035781,317383,187862,557295,106602,343972,1036885,512119,619035,675774,323315,875856,741945,439435,866973,435487,801937,348682,470105,459386,894086,283322,474717,909113,995530,659562,302538,389391,648343,457116,22880,604122,478885,88867,120478,1035350,20067,572248,776959,964075,806083,231136,838999,280559,416678,982316,216216,651346,949306,167077,82743,98331,781515,407226,415132,452739,638659,844447,1007757) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]