SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507254 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507254 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558434,348803,629317,911548,1020627,270776,832290,374813,115915,518681,741587,578906,7959,60472,1043395,423001,689668,501138,1042620,652043,57054,1031931,13729,969668,837151,1000543,507469,932247,592261,105554,522178,658401,457375,385884,719395,972341,566153,876156,508141,103236,423103,676851,265392,578697,400932,847983,301792,887739,915038,839525,582574,984194,548651,487645,807799,764896,807191,479920,914506,58873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]