SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417582 LIMIT 1 [ RunTime:0.001243s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417582 [ RunTime:0.003473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (901739,808947,186356,663728,224092,320125,478366,573788,62374,290214,428869,85648,966910,909003,692214,141856,245167,300087,79774,998285,314009,548853,271083,91464,35188,1011146,595807,945021,292724,238624,261814,295020,831722,366999,230490,835737,99811,505298,1006252,131809,18155,930303,82786,20132,829002,750304,763117,571142,454301,712588,240515,458206,253699,261671,185007,848337,244474,782671,201129,961340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000846s ]