SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 250054 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 250054 [ RunTime:0.004611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240596,874568,628348,730811,410681,659587,919535,196535,570108,38338,837671,499404,877424,150855,257571,169483,608487,588318,729939,950489,365498,310392,275755,332013,152042,849135,807497,111775,721470,359059,593123,568469,178647,592850,421723,1015494,810162,882100,886940,114308,152127,244802,557892,575310,874635,887352,279190,652432,520892,873608,265696,500736,224653,643971,423416,769247,380379,93905,759298,921222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 250054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 250054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000689s ]