SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487839 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487839 [ RunTime:0.002704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147526,61136,247719,341044,48540,534142,824405,877406,561616,997929,742521,486941,25295,972826,639095,892043,784281,569205,684785,23638,687681,47642,998429,983432,500480,325396,628925,799060,118253,728502,554681,90375,415282,287544,606181,585614,220171,461404,771400,690991,235553,180911,685833,993717,696059,452071,108023,668795,966585,171768,378119,690698,927242,235864,1035193,439201,753015,900291,459777,329972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487839 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487839 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]