SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531581 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531581 [ RunTime:0.006306s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320199,607771,58113,641466,49851,492260,389937,154573,1029556,959817,420037,423181,661654,1034445,134603,927071,723367,934006,883158,983275,872897,567975,621209,781212,745058,341206,897864,745928,691475,670211,893860,933182,294181,774277,445053,434303,492583,256844,356279,456508,322006,369743,370705,961809,934642,45003,997462,1023957,684469,249694,406373,414993,697533,1010047,299173,392908,655780,554586,777473,925338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001673s ]