SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405334 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405334 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284541,105075,178465,424204,94553,493221,306768,919819,931753,561406,899516,319474,652496,213387,364270,498828,218729,842485,260556,1034812,939268,756495,177584,478292,284834,738290,794588,946440,465534,460771,570624,497811,481471,69300,298629,552507,560316,750748,472257,976018,222295,355032,912563,21191,1024468,1030501,872450,349358,905760,37862,366749,338398,254452,586289,157041,860202,505659,734409,19013,547228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405334 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405334 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]