SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504737 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504737 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035450,729356,461987,441848,555961,850582,519985,105499,1010167,138054,994668,931896,1041442,882395,453367,823220,590980,421277,876378,877656,108012,925448,719647,989455,160523,577274,1014082,305782,799853,676393,253127,70809,367306,776605,584491,365216,15641,287309,860604,47505,927018,894747,1001946,1037850,834503,314091,118267,895383,923861,404546,79009,846103,946956,472140,115919,451295,686493,315833,501917,1021550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504737 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504737 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]