SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424772 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424772 [ RunTime:0.001863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56752,333415,140941,100092,699134,1027231,162510,643279,387755,492827,772242,62567,737508,110587,219285,1037625,63709,523677,206606,242696,245,32138,304972,833947,872013,800247,57878,322447,1004869,460982,523695,1006558,334160,346850,970163,705449,997610,107301,305183,608075,1048910,293085,406275,178051,790725,1042705,717835,189511,201580,342009,404449,681092,676540,491500,793410,734020,98791,520990,192378,919524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424772 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424772 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]