SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396083 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396083 [ RunTime:0.003036s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593610,737860,892307,282601,777141,873954,298198,375635,433692,302211,687270,195300,524926,391608,87536,503688,423886,336082,424749,224762,452232,360217,689661,946378,988803,1018280,362819,934182,901585,780449,692940,852382,509292,713977,21658,865054,492567,951363,15637,444564,700879,452372,310157,90737,45671,277708,310943,159042,707426,692975,729405,609787,750636,833503,955394,754231,497715,436794,899498,835808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000729s ]