SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 682541 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 682541 [ RunTime:0.002085s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98278,1004746,687501,120475,152963,477495,706624,613558,214553,518364,31314,733562,61723,383485,303174,668950,151776,720502,946991,35478,226390,318384,37136,481687,567368,930879,937727,35211,188386,951907,506724,1000850,282635,36520,535649,305723,336491,421263,472982,846672,855384,911833,721126,682557,926365,926810,190694,141286,80958,380793,290675,245414,618358,644494,974057,921028,254745,402068,363210,270340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 682541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 682541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000679s ]