SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400035 LIMIT 1 [ RunTime:0.001102s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400035 [ RunTime:0.004615s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (807739,575227,653716,733123,345741,974550,698876,828989,733057,260112,910835,100798,120876,45492,133961,18401,383973,509297,446349,757728,298026,238274,770185,550037,33787,949759,575585,586681,948710,159838,755913,353089,93143,76916,215247,904706,437458,691396,10469,347655,363937,659254,292651,815353,420904,986158,169889,366762,525456,314054,991514,304485,475011,425003,473049,962067,50733,775226,732327,921447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000970s ]