SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455944 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455944 [ RunTime:0.003386s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383072,160511,177011,1014967,861290,777896,568427,803526,865327,677686,281984,990153,542887,642762,989038,637053,527725,265126,778130,806154,1012380,795893,287243,324201,456229,470900,269109,948131,626187,347875,34315,375415,508757,497389,573308,749724,580214,936450,464036,45161,820967,249333,159534,471336,115107,317089,673257,249214,789100,695140,787380,170975,201089,399184,312502,150814,381662,573063,542800,16319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455944 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455944 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000837s ]