SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580846 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580846 [ RunTime:0.003094s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506162,753504,504862,22047,790610,992806,404811,81543,801802,993919,894475,267025,352348,971667,565496,370720,820362,286949,65336,300218,47545,442355,661856,520998,12918,242819,728961,583036,546485,304225,1009133,77458,505238,840172,775815,182252,814321,21623,805067,836524,149363,784065,499270,659653,980106,374943,992679,391863,592897,632015,255054,212684,533873,795181,915574,420205,272300,954035,77120,635147) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001728s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]