SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398148 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398148 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545962,291942,548618,862365,934150,597311,1007612,99113,43678,11035,501130,326375,645720,370744,1021977,612978,11820,395182,130060,275868,850399,1006269,591647,235653,777945,734681,284211,413721,688939,909503,930553,571866,347173,833855,31404,44307,112609,523478,995949,58632,84396,71425,358021,829,582620,388988,603552,676865,534445,15286,959951,887613,238300,878788,990945,684093,794127,34986,113902,624210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]