SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413876 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413876 [ RunTime:0.002317s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321843,922193,743709,843985,249740,715854,552510,701281,135829,801890,26659,834891,759413,334292,452150,818948,946576,703331,18044,332845,637558,458402,612078,825732,655982,1009746,211404,217974,169232,809506,433664,572675,970612,1015974,22178,857694,927258,262603,84545,643748,502695,366937,417646,456445,219976,1007162,100739,866524,211651,227010,755845,274722,728073,1044170,555930,1036084,345931,172834,637950,281569) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]