SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001617s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005325 LIMIT 1 [ RunTime:0.000907s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005325 [ RunTime:0.004787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043801,314630,695428,258587,529054,806871,75409,855442,164849,572929,802920,68307,714321,865180,678821,131225,408687,188655,902284,747604,775077,266919,418138,613832,1015068,652307,14545,5897,18679,373895,1003717,566500,467220,818777,98111,97523,776979,69943,877714,559201,518505,469840,238307,673693,732757,265576,442523,493693,676978,982557,285526,867540,25097,102730,1212,247696,84262,336446,783282,865316) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005325 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005325 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001220s ]