SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001568s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485038 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485038 [ RunTime:0.001822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (794707,401234,242192,210156,556446,408000,474685,254489,56023,976651,814895,721711,510753,202789,346518,101431,902361,78815,621852,362709,677665,44102,432302,241127,22515,961097,872434,197247,289121,826070,288031,316284,506428,44823,1013053,168220,1048847,504583,977533,133776,129622,421281,375919,242194,228876,122701,706671,828159,485601,756679,417085,896734,782090,472738,152445,229020,534122,105911,704874,299416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001682s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]