SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501982 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501982 [ RunTime:0.003429s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467890,252369,956062,385839,224410,177724,590795,219302,613372,405896,931146,630924,310293,683985,745780,181321,283956,728900,156625,236609,236936,600435,419055,271694,368901,219294,283486,948933,490749,112395,14241,127988,211535,1022728,381005,240695,416785,1024101,465971,1043206,541021,694662,77434,258811,331569,385965,737774,21938,145673,790563,196959,814026,174513,977244,262823,821063,359527,780644,238868,818018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501982 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501982 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]