SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043290 LIMIT 1 [ RunTime:0.003526s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043290 [ RunTime:0.010523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39550,203031,133278,965656,894587,660478,912977,445989,189874,89359,562039,894421,507901,717905,434166,701473,992500,777992,354147,182628,406629,123027,915668,339261,291083,739837,548938,356274,852072,422131,419486,318378,945626,596686,24958,566706,723423,1019063,378050,493542,60752,916259,954427,836445,318916,211893,461749,368380,435657,614597,201112,336685,840713,593673,393539,419247,23681,881845,167881,12683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043290 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000662s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043290 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]