SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41440 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41440 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301674,436894,462413,377761,195270,400127,602395,59403,172325,305361,42061,1010314,910743,544645,1026219,149754,583008,9418,520858,504470,270480,320861,317033,884609,1033774,590418,883141,817612,764075,530544,547753,877205,711138,431572,893566,967017,1043044,695693,120265,869375,1010369,363791,577610,945086,53180,415448,364763,764446,106919,670558,303087,530963,222423,653511,298808,653910,436628,51882,940962,585354) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]