SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449506 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449506 [ RunTime:0.002418s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486107,835951,1002263,581429,660521,117459,171462,370703,124812,662918,585459,754859,270784,264206,297592,468526,294011,957054,750099,747999,811648,376783,690433,230870,908019,667168,817587,758385,249900,458555,189334,129265,922416,787652,272387,978936,365076,615719,45136,644228,671474,520547,657258,893385,281222,609959,374366,791401,871958,910936,722292,559103,67598,224099,208279,529317,386009,956739,576074,184564) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]